from sqlalchemy import Column, Integer, ForeignKey, Table
from database.db import Base


# 任务场景和检测目标的多对多关联表
task_scenario_detection_targets = Table(
    'task_scenario_detection_targets',
    Base.metadata,
    Column('task_scenario_id', Integer, ForeignKey('task_scenarios.id'), primary_key=True, comment="任务场景ID"),
    Column('detection_target_id', Integer, ForeignKey('detection_targets.id'), primary_key=True, comment="检测目标ID")
)